USE [eve]
GO

/****** Object:  Table [dbo].[invMarketGroups]    Script Date: 04/13/2011 19:06:40 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[invMarketGroups](
	[marketGroupID] [smallint] NOT NULL,
	[parentGroupID] [smallint] NULL,
	[marketGroupName] [nvarchar](100) NULL,
	[description] [nvarchar](3000) NULL,
	[iconID] [int] NULL,
	[hasTypes] [bit] NULL,
 CONSTRAINT [invMarketGroups_PK] PRIMARY KEY CLUSTERED 
(
	[marketGroupID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

ALTER TABLE [dbo].[invMarketGroups]  WITH CHECK ADD  CONSTRAINT [FKC8E1C7C19D5C02] FOREIGN KEY([parentGroupID])
REFERENCES [dbo].[invMarketGroups] ([marketGroupID])
GO

ALTER TABLE [dbo].[invMarketGroups] CHECK CONSTRAINT [FKC8E1C7C19D5C02]
GO

